
-----------------------------------------------------------------------------
-- DDL for Table'common.dbo.t_DatabaseName'
-----------------------------------------------------------------------------
print 'Creating Table common.dbo.t_DatabaseName'
go 

use common
go 

setuser 'dbo'
go 
drop table t_DatabaseName
go
CREATE TABLE t_DatabaseName ( 
    DBName   	varchar(30) NULL,
    LoginName	varchar(30) NULL,
    Pass     	varchar(50) NULL,
    Hostname 	varchar(250) NULL,
    Port     	varchar(50) NULL,
    DBType   	varchar(50) NULL 
    )
go


Grant Select on dbo.t_DatabaseName to public 
go

setuser
go 

